package com.dingding.service.account.core.tailwind.sql;

/**
 * 
 * @ClassName: DepositAccountSQL 
 * @Description: 提现账户SQL类
 * @author YHQ
 * @date 2016年12月21日 下午4:26:13
 * @since V2.5.8
 * 
 */
public class DepositAccountSQL {

	/**
	 * 
	 * @author YHQ
	 * @Description: 获取顺风车司机提现账户认证状态
	 * 
	 */
	public static String GET_USER_ACCOUNT_AUTHENTICATION_STATUS = "SELECT s.isDeposit FROM userlogin s WHERE s.uid = ?";
	
	/**
	 * 
	 * @author YHQ
	 * @Description: 根据用户Id删除提现账户
	 * 
	 */
	public static final String DELETE_DEPOSIT_ACCOUNT = "UPDATE dd_passanger_deposit_account SET depositAccountStatus = 2 WHERE depositAccountId = ? AND passangerUserId = ?";
	
	/**
	 * 
	 * @author YHQ
	 * @Description: 根据用户id获取提现账户列表(启用)
	 */
	public static final String GET_DEPOSIT_ACCOUNT_LIST = "SELECT d.depositAccountId,d.depositAccount,d.depositAccountName FROM dd_passanger_deposit_account d WHERE d.passangerUserId = ? AND d.depositAccountStatus = 1";
	
	/**
	 * 
	 * @author YHQ
	 * @Description: 根据用户id获取提现账户列表(启用和禁用)
	 */
	public static final String GET_ALL_DEPOSIT_ACCOUNT_LIST = "SELECT depositAccountId, passangerUserId, depositAccount, depositAccountName, createTime, depositAccountStatus FROM dd_passanger_deposit_account WHERE passangerUserId = ?";
	
}
